Getting Started with SQL Server 2012 Cube Development by 2013

Author:2013
Language: eng
Format: epub
Publisher: Packt Publishing

This will calculate the Sales Amount plus 10 percent.

Add your new Sales plus 10 pct measure to your PivotTable.

Note

When you do this, you have to specify the formatting for your new calculated measure as within your PivotTable. The easiest way to do this is to remove everything except the newly created measure from your PivotTable and then set the required formatting to the single cell. After this you can add the other objects to the PivotTable.

Another way that you can create calculated columns within a PivotTable is to follow the given steps:

Right-click on any value within a PivotTable and choose Show Values As.

Select how you want to display your value, in the example click on % of Grand Total.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.